package com.iotechn.unimall.data.dto.statistics;

import cn.afterturn.easypoi.excel.annotation.Excel;
import lombok.Data;

/**
 * @author chen
 */
@Data
public class StoreSkuMonthlyExcelDTO {

    @Excel(name = "分类名称")
    private String categroyName;
    @Excel(name = "商品条码")
    private  String storeSkuBarCode;
    @Excel(name = "商品名称")
    private  String storeSkuName;
    /** 月平均 */
    @Excel(name = "月平均金额")
    private Float monthAvgPriceKey;
    /** 期初 */
    @Excel(name = "期初库存")
    private Float monthBeginNumKey;
    @Excel(name = "期初金额")
    private Float monthBeginAmountKey;
    @Excel(name = "期初单价")
    private Float monthBeginPriceKey;
    /** 门店入库 */
    @Excel(name = "门店入库数量")
    private  Float stcokEntryNum;
    @Excel(name = "门店入库金额")
    private  Float stcokEntryAmount;
    /** 门店销售 */
    @Excel(name = "门店销售数量")
    private  Float storeOrderSaleNum;
    @Excel(name = "门店销售金额")
    private  Float storeOrderSaleAmount;
    @Excel(name = "门店销售成本")
    private  Float storeOrderSaleCost;
    /** 门店损耗 */
    @Excel(name = "门店损耗数量")
    private  Float storeLossReportNum;
    @Excel(name = "门店损耗金额")
    private  Float storeLossReportAmount;
    /** 品鉴 */
    @Excel(name = "品鉴数量")
    private  Float storeLossJudgeNum;
    @Excel(name = "品鉴金额")
    private  Float storeLossJudgeAmount;
    /** 调入 */
    @Excel(name = "调入数量")
    private  Float storeTransferInNum;
    @Excel(name = "调入金额")
    private  Float storeTransferInAmount;
    /** 调出 */
    @Excel(name = "调出数量")
    private  Float storeTransferOutNum;
    @Excel(name = "调出金额")
    private  Float storeTransferOutAmount;
    /** 退库 */
    @Excel(name = "退库数量")
    private  Float storeStockReturnNum;
    @Excel(name = "退库金额")
    private  Float storeStockReturnAmount;
    /** 盘盈 */
    @Excel(name = "盘盈数量")
    private  Float storeInventorySurplusNum;
    @Excel(name = "盘盈金额")
    private  Float storeInventorySurplusAmount;
    /** 盘亏 */
    @Excel(name = "盘亏数量")
    private  Float storeInventoryLossNum;
    @Excel(name = "盘亏金额")
    private  Float storeInventoryLossAmount;
    /** 拆箱出库 */
    @Excel(name = "拆箱出库数量")
    private  Float storePackageOutNum;
    @Excel(name = "拆箱出库金额")
    private  Float storePackageOutAmount;
    /** 拆箱入库 */
    @Excel(name = "拆箱入库数量")
    private  Float storePackageInNum;
    @Excel(name = "拆箱入库金额")
    private  Float storePackageInAmount;
    /** 退货 */
    @Excel(name = "退货数量")
    private  Float storeReturnGoodsNum;
    @Excel(name = "退货金额")
    private  Float storeReturnGoodsAmount;
    @Excel(name = "退货成本")
    private Float storeReturnGoodsCost;
    /** 期末 */
    @Excel(name = "期末库存")
    private Float monthFinalNumKey;
    @Excel(name = "期末金额")
    private Float monthFinalAmountKey;
    /**********************   平衡  ****************************/
    /** */
    @Excel(name = "库存平衡计算")
    private Float balanceNumResult;
    /**净入库金额 = 入库 - 调出 + 调入 -退库 */
    @Excel(name = "净入库金额 ")
    private Float cleanStcokEntryAmount;
    /** 净销售 = 销售 - 退货 */
    @Excel(name = "净销售金额")
    private Float cleanStoreOrderSaleAmount;
    /** 净损耗 = 损耗 + 盘损 - 盘盈 */
    @Excel(name = "净损耗金额")
    private Float cleanStoreLossReportAmount;
    /** 净成本 = 销售成本 - 退货成本 */
    @Excel(name = "净成本金额")
    private Float cleanStoreCost;
    /** 平衡 = 起初 + 净入库 - 净损耗 - 净成本 - 期末 */
    @Excel(name = "金额平衡计算")
    private Float balanceAmountResult;
}
